﻿CREATE TABLE [dbo].[AngajatiOcupatii] (
    [IDOcupatieAngajat] INT      IDENTITY (1, 1) NOT NULL,
    [IDOcupatie]        INT      NOT NULL,
    [DeLaData]          DATETIME NOT NULL,
    [PanaLaData]        DATETIME NULL,
    [IDPersoana]        INT      NOT NULL,
    CONSTRAINT [PK_AngajatiOcupatii] PRIMARY KEY CLUSTERED ([IDOcupatieAngajat] ASC),
    CONSTRAINT [FK_AngajatiOcupatii_Ocupatii] FOREIGN KEY ([IDOcupatie]) REFERENCES [dbo].[Ocupatii] ([IDOcupatie]),
    CONSTRAINT [FK_AngajatiOcupatii_Persoane] FOREIGN KEY ([IDPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

